Dataset statistics
| Number of variables | 20 |
|---|---|
| Number of observations | 4027 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 601.8 KiB |
| Average record size in memory | 153.0 B |
Variable types
| Text | 3 |
|---|---|
| Numeric | 4 |
| Categorical | 11 |
| DateTime | 1 |
| Boolean | 1 |
card_number is highly overall correlated with customer_segment and 3 other fields | High correlation |
trans_amount is highly overall correlated with fake | High correlation |
customer_segment is highly overall correlated with card_number | High correlation |
card_type is highly overall correlated with card_number | High correlation |
customer_location is highly overall correlated with card_number and 1 other fields | High correlation |
merchant_name is highly overall correlated with fake | High correlation |
trans_loc is highly overall correlated with card_number and 1 other fields | High correlation |
trans_currency is highly overall correlated with fake | High correlation |
fake is highly overall correlated with trans_amount and 2 other fields | High correlation |
trans_currency is highly imbalanced (59.0%) | Imbalance |
trans_id has unique values | Unique |
trans_approval_code has unique values | Unique |
Reproduction
| Analysis started | 2023-09-09 00:46:25.227417 |
|---|---|
| Analysis finished | 2023-09-09 00:48:45.085118 |
| Duration | 2 minutes and 19.86 seconds |
| Software version | ydata-profiling vv4.5.1 |
| Download configuration | config.json |
cardholder_name
Text
| Distinct | 992 |
|---|---|
| Distinct (%) | 24.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 31.6 KiB |
Length
| Max length | 28 |
|---|---|
| Median length | 22 |
| Mean length | 13.31711 |
| Min length | 8 |
Characters and Unicode
| Total characters | 53628 |
|---|---|
| Distinct characters | 52 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Kaitlin Edwards |
|---|---|
| 2nd row | Kaitlin Edwards |
| 3rd row | Kyle Armstrong |
| 4th row | Kyle Armstrong |
| 5th row | Kyle Armstrong |
| Value | Count | Frequency (%) |
| smith | 134 | 1.6% |
| david | 91 | 1.1% |
| brown | 80 | 1.0% |
| james | 77 | 0.9% |
| christopher | 77 | 0.9% |
| michael | 74 | 0.9% |
| jennifer | 71 | 0.9% |
| robert | 65 | 0.8% |
| williams | 64 | 0.8% |
| john | 63 | 0.8% |
| Other values (805) | 7432 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 5059 | 9.4% |
| e | 4870 | 9.1% |
| 4201 | 7.8% | |
| r | 3902 | 7.3% |
| n | 3849 | 7.2% |
| i | 3356 | 6.3% |
| o | 2947 | 5.5% |
| l | 2728 | 5.1% |
| s | 2392 | 4.5% |
| t | 1782 | 3.3% |
| Other values (42) | 18542 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 40985 | |
| Uppercase Letter | 8374 | 15.6% |
| Space Separator | 4201 | 7.8% |
| Other Punctuation | 68 | 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 5059 | |
| e | 4870 | |
| r | 3902 | |
| n | 3849 | |
| i | 3356 | 8.2% |
| o | 2947 | 7.2% |
| l | 2728 | 6.7% |
| s | 2392 | 5.8% |
| t | 1782 | 4.3% |
| h | 1710 | 4.2% |
| Other values (16) | 8390 |
Uppercase Letter
| Value | Count | Frequency (%) |
| M | 863 | 10.3% |
| J | 819 | 9.8% |
| A | 615 | 7.3% |
| C | 593 | 7.1% |
| D | 582 | 7.0% |
| S | 573 | 6.8% |
| B | 570 | 6.8% |
| R | 556 | 6.6% |
| W | 427 | 5.1% |
| H | 388 | 4.6% |
| Other values (14) | 2388 |
Space Separator
| Value | Count | Frequency (%) |
| 4201 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 68 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 49359 | |
| Common | 4269 | 8.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 5059 | 10.2% |
| e | 4870 | 9.9% |
| r | 3902 | 7.9% |
| n | 3849 | 7.8% |
| i | 3356 | 6.8% |
| o | 2947 | 6.0% |
| l | 2728 | 5.5% |
| s | 2392 | 4.8% |
| t | 1782 | 3.6% |
| h | 1710 | 3.5% |
| Other values (40) | 16764 |
Common
| Value | Count | Frequency (%) |
| 4201 | ||
| . | 68 | 1.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 53628 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 5059 | 9.4% |
| e | 4870 | 9.1% |
| 4201 | 7.8% | |
| r | 3902 | 7.3% |
| n | 3849 | 7.2% |
| i | 3356 | 6.3% |
| o | 2947 | 5.5% |
| l | 2728 | 5.1% |
| s | 2392 | 4.5% |
| t | 1782 | 3.3% |
| Other values (42) | 18542 |
card_number
Real number (ℝ)
HIGH CORRELATION
| Distinct | 1000 |
|---|---|
| Distinct (%) | 24.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.1044664 × 1011 |
| Minimum | 1.0643483 × 108 |
|---|---|
| Maximum | 9.9816735 × 1011 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 31.6 KiB |
Quantile statistics
| Minimum | 1.0643483 × 108 |
|---|---|
| 5-th percentile | 4.6308004 × 1010 |
| Q1 | 2.4712208 × 1011 |
| median | 5.234143 × 1011 |
| Q3 | 7.8276933 × 1011 |
| 95-th percentile | 9.4903125 × 1011 |
| Maximum | 9.9816735 × 1011 |
| Range | 9.9806091 × 1011 |
| Interquartile range (IQR) | 5.3564726 × 1011 |
Descriptive statistics
| Standard deviation | 3.0148029 × 1011 |
|---|---|
| Coefficient of variation (CV) | 0.59062058 |
| Kurtosis | -1.2963502 |
| Mean | 5.1044664 × 1011 |
| Median Absolute Deviation (MAD) | 2.6747445 × 1011 |
| Skewness | -0.060387536 |
| Sum | 2.0555686 × 1015 |
| Variance | 9.0890366 × 1022 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 7.945507785 × 1011 | 6 | 0.1% |
| 3.697327146 × 1011 | 6 | 0.1% |
| 5.168595377 × 1011 | 6 | 0.1% |
| 5.3052258 × 1011 | 6 | 0.1% |
| 6.803811798 × 1011 | 6 | 0.1% |
| 9.191467717 × 1011 | 6 | 0.1% |
| 4.990108615 × 1011 | 6 | 0.1% |
| 4.171436207 × 1011 | 6 | 0.1% |
| 8.371353589 × 1011 | 6 | 0.1% |
| 9.962911911 × 1011 | 6 | 0.1% |
| Other values (990) | 3967 |
| Value | Count | Frequency (%) |
| 106434833 | 5 | |
| 199806849 | 6 | |
| 1418313629 | 3 | |
| 2039434588 | 4 | |
| 2716596742 | 5 | |
| 2891370518 | 4 | |
| 2920966534 | 5 | |
| 2999893985 | 6 | |
| 5137516005 | 2 | < 0.1% |
| 6647279318 | 5 |
| Value | Count | Frequency (%) |
| 9.981673484 × 1011 | 3 | |
| 9.971857143 × 1011 | 5 | |
| 9.962911911 × 1011 | 6 | |
| 9.954227176 × 1011 | 2 | < 0.1% |
| 9.947235405 × 1011 | 3 | |
| 9.940009864 × 1011 | 5 | |
| 9.937132356 × 1011 | 4 | |
| 9.935182464 × 1011 | 5 | |
| 9.891801355 × 1011 | 3 | |
| 9.888544788 × 1011 | 3 |
customer_age
Real number (ℝ)
| Distinct | 50 |
|---|---|
| Distinct (%) | 1.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 43.144276 |
| Minimum | 18 |
|---|---|
| Maximum | 69 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 31.6 KiB |
Quantile statistics
| Minimum | 18 |
|---|---|
| 5-th percentile | 20 |
| Q1 | 29 |
| median | 42 |
| Q3 | 56 |
| 95-th percentile | 67 |
| Maximum | 69 |
| Range | 51 |
| Interquartile range (IQR) | 27 |
Descriptive statistics
| Standard deviation | 15.743324 |
|---|---|
| Coefficient of variation (CV) | 0.36489948 |
| Kurtosis | -1.3017135 |
| Mean | 43.144276 |
| Median Absolute Deviation (MAD) | 14 |
| Skewness | 0.031685929 |
| Sum | 173742 |
| Variance | 247.85225 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 39 | 192 | 4.8% |
| 29 | 171 | 4.2% |
| 63 | 146 | 3.6% |
| 60 | 144 | 3.6% |
| 18 | 141 | 3.5% |
| 69 | 138 | 3.4% |
| 55 | 134 | 3.3% |
| 51 | 128 | 3.2% |
| 66 | 127 | 3.2% |
| 47 | 126 | 3.1% |
| Other values (40) | 2580 |
| Value | Count | Frequency (%) |
| 18 | 141 | |
| 19 | 55 | 1.4% |
| 20 | 107 | |
| 21 | 62 | |
| 22 | 119 | |
| 23 | 80 | |
| 25 | 124 | |
| 26 | 91 | |
| 27 | 84 | |
| 28 | 81 |
| Value | Count | Frequency (%) |
| 69 | 138 | |
| 68 | 5 | 0.1% |
| 67 | 106 | |
| 66 | 127 | |
| 65 | 36 | 0.9% |
| 64 | 71 | |
| 63 | 146 | |
| 62 | 35 | 0.9% |
| 61 | 122 | |
| 60 | 144 |
customer_segment
Categorical
HIGH CORRELATION
| Distinct | 5 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 31.6 KiB |
| Other | |
|---|---|
| Retail | |
| Student | |
| Premium | |
| Business |
Length
| Max length | 8 |
|---|---|
| Median length | 7 |
| Mean length | 6.5612118 |
| Min length | 5 |
Characters and Unicode
| Total characters | 26422 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Business |
|---|---|
| 2nd row | Business |
| 3rd row | Retail |
| 4th row | Retail |
| 5th row | Retail |
Common Values
| Value | Count | Frequency (%) |
| Other | 852 | |
| Retail | 829 | |
| Student | 809 | |
| Premium | 771 | |
| Business | 766 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| other | 852 | |
| retail | 829 | |
| student | 809 | |
| premium | 771 | |
| business | 766 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 4027 | |
| t | 3299 | |
| i | 2366 | |
| u | 2346 | |
| s | 2298 | |
| r | 1623 | 6.1% |
| n | 1575 | 6.0% |
| m | 1542 | 5.8% |
| O | 852 | 3.2% |
| h | 852 | 3.2% |
| Other values (7) | 5642 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 22395 | |
| Uppercase Letter | 4027 | 15.2% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 4027 | |
| t | 3299 | |
| i | 2366 | |
| u | 2346 | |
| s | 2298 | |
| r | 1623 | |
| n | 1575 | 7.0% |
| m | 1542 | 6.9% |
| h | 852 | 3.8% |
| a | 829 | 3.7% |
| Other values (2) | 1638 |
Uppercase Letter
| Value | Count | Frequency (%) |
| O | 852 | |
| R | 829 | |
| S | 809 | |
| P | 771 | |
| B | 766 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 26422 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 4027 | |
| t | 3299 | |
| i | 2366 | |
| u | 2346 | |
| s | 2298 | |
| r | 1623 | 6.1% |
| n | 1575 | 6.0% |
| m | 1542 | 5.8% |
| O | 852 | 3.2% |
| h | 852 | 3.2% |
| Other values (7) | 5642 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 26422 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 4027 | |
| t | 3299 | |
| i | 2366 | |
| u | 2346 | |
| s | 2298 | |
| r | 1623 | 6.1% |
| n | 1575 | 6.0% |
| m | 1542 | 5.8% |
| O | 852 | 3.2% |
| h | 852 | 3.2% |
| Other values (7) | 5642 |
card_type
Categorical
HIGH CORRELATION
| Distinct | 5 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 31.6 KiB |
| American Express | |
|---|---|
| Visa | |
| MasterCard | |
| Rupay | |
| Other |
Length
| Max length | 16 |
|---|---|
| Median length | 10 |
| Mean length | 8.2485721 |
| Min length | 4 |
Characters and Unicode
| Total characters | 33217 |
|---|---|
| Distinct characters | 23 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | MasterCard |
|---|---|
| 2nd row | MasterCard |
| 3rd row | American Express |
| 4th row | American Express |
| 5th row | American Express |
Common Values
| Value | Count | Frequency (%) |
| American Express | 901 | |
| Visa | 804 | |
| MasterCard | 795 | |
| Rupay | 773 | |
| Other | 754 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| american | 901 | |
| express | 901 | |
| visa | 804 | |
| mastercard | 795 | |
| rupay | 773 | |
| other | 754 |
Most occurring characters
| Value | Count | Frequency (%) |
| r | 4146 | 12.5% |
| a | 4068 | 12.2% |
| s | 3401 | 10.2% |
| e | 3351 | 10.1% |
| i | 1705 | 5.1% |
| p | 1674 | 5.0% |
| t | 1549 | 4.7% |
| x | 901 | 2.7% |
| m | 901 | 2.7% |
| A | 901 | 2.7% |
| Other values (13) | 10620 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 26593 | |
| Uppercase Letter | 5723 | 17.2% |
| Space Separator | 901 | 2.7% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| r | 4146 | |
| a | 4068 | |
| s | 3401 | |
| e | 3351 | |
| i | 1705 | |
| p | 1674 | |
| t | 1549 | 5.8% |
| x | 901 | 3.4% |
| m | 901 | 3.4% |
| n | 901 | 3.4% |
| Other values (5) | 3996 |
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 901 | |
| E | 901 | |
| V | 804 | |
| M | 795 | |
| C | 795 | |
| R | 773 | |
| O | 754 |
Space Separator
| Value | Count | Frequency (%) |
| 901 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 32316 | |
| Common | 901 | 2.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| r | 4146 | |
| a | 4068 | |
| s | 3401 | 10.5% |
| e | 3351 | 10.4% |
| i | 1705 | 5.3% |
| p | 1674 | 5.2% |
| t | 1549 | 4.8% |
| x | 901 | 2.8% |
| m | 901 | 2.8% |
| A | 901 | 2.8% |
| Other values (12) | 9719 |
Common
| Value | Count | Frequency (%) |
| 901 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 33217 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| r | 4146 | 12.5% |
| a | 4068 | 12.2% |
| s | 3401 | 10.2% |
| e | 3351 | 10.1% |
| i | 1705 | 5.1% |
| p | 1674 | 5.0% |
| t | 1549 | 4.7% |
| x | 901 | 2.7% |
| m | 901 | 2.7% |
| A | 901 | 2.7% |
| Other values (13) | 10620 |
customer_location
Categorical
HIGH CORRELATION
| Distinct | 10 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 31.6 KiB |
| Delhi | |
|---|---|
| Chennai | |
| Pune | |
| Jaipur | |
| Hyderabad | |
| Other values (5) |
Length
| Max length | 9 |
|---|---|
| Median length | 7 |
| Mean length | 6.7698038 |
| Min length | 4 |
Characters and Unicode
| Total characters | 27262 |
|---|---|
| Distinct characters | 29 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Delhi |
|---|---|
| 2nd row | Delhi |
| 3rd row | Jaipur |
| 4th row | Jaipur |
| 5th row | Jaipur |
Common Values
| Value | Count | Frequency (%) |
| Delhi | 507 | |
| Chennai | 472 | |
| Pune | 451 | |
| Jaipur | 419 | |
| Hyderabad | 419 | |
| Kolkata | 406 | |
| Bangalore | 357 | |
| Lucknow | 349 | |
| Mumbai | 329 | |
| Ahmedabad | 318 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| delhi | 507 | |
| chennai | 472 | |
| pune | 451 | |
| jaipur | 419 | |
| hyderabad | 419 | |
| kolkata | 406 | |
| bangalore | 357 | |
| lucknow | 349 | |
| mumbai | 329 | |
| ahmedabad | 318 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 4220 | |
| e | 2524 | 9.3% |
| n | 2101 | 7.7% |
| i | 1727 | 6.3% |
| u | 1548 | 5.7% |
| d | 1474 | 5.4% |
| h | 1297 | 4.8% |
| l | 1270 | 4.7% |
| r | 1195 | 4.4% |
| o | 1112 | 4.1% |
| Other values (19) | 8794 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 23235 | |
| Uppercase Letter | 4027 | 14.8% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 4220 | |
| e | 2524 | |
| n | 2101 | |
| i | 1727 | 7.4% |
| u | 1548 | 6.7% |
| d | 1474 | 6.3% |
| h | 1297 | 5.6% |
| l | 1270 | 5.5% |
| r | 1195 | 5.1% |
| o | 1112 | 4.8% |
| Other values (9) | 4767 |
Uppercase Letter
| Value | Count | Frequency (%) |
| D | 507 | |
| C | 472 | |
| P | 451 | |
| H | 419 | |
| J | 419 | |
| K | 406 | |
| B | 357 | |
| L | 349 | |
| M | 329 | |
| A | 318 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 27262 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 4220 | |
| e | 2524 | 9.3% |
| n | 2101 | 7.7% |
| i | 1727 | 6.3% |
| u | 1548 | 5.7% |
| d | 1474 | 5.4% |
| h | 1297 | 4.8% |
| l | 1270 | 4.7% |
| r | 1195 | 4.4% |
| o | 1112 | 4.1% |
| Other values (19) | 8794 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 27262 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 4220 | |
| e | 2524 | 9.3% |
| n | 2101 | 7.7% |
| i | 1727 | 6.3% |
| u | 1548 | 5.7% |
| d | 1474 | 5.4% |
| h | 1297 | 4.8% |
| l | 1270 | 4.7% |
| r | 1195 | 4.4% |
| o | 1112 | 4.1% |
| Other values (19) | 8794 |
merchant_name
Categorical
HIGH CORRELATION
| Distinct | 18 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 31.6 KiB |
| amazon gift cards | |
|---|---|
| amazon | |
| swiggy | |
| zomato | |
| rakuten | |
| Other values (13) |
Length
| Max length | 17 |
|---|---|
| Median length | 15 |
| Mean length | 9.7035014 |
| Min length | 6 |
Characters and Unicode
| Total characters | 39076 |
|---|---|
| Distinct characters | 32 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | airtel |
|---|---|
| 2nd row | amazon |
| 3rd row | chai talks |
| 4th row | fake_merchant_6 |
| 5th row | instamart |
Common Values
| Value | Count | Frequency (%) |
| amazon gift cards | 446 | |
| amazon | 425 | |
| swiggy | 420 | |
| zomato | 413 | |
| rakuten | 403 | |
| airtel | 400 | |
| instamart | 380 | |
| chai talks | 359 | |
| fake_merchant_9 | 95 | 2.4% |
| fake_merchant_1 | 84 | 2.1% |
| Other values (8) | 602 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| amazon | 871 | |
| gift | 446 | |
| cards | 446 | |
| swiggy | 420 | |
| zomato | 413 | |
| rakuten | 403 | |
| airtel | 400 | |
| instamart | 380 | |
| chai | 359 | |
| talks | 359 | |
| Other values (10) | 781 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 6444 | |
| t | 3562 | 9.1% |
| m | 2445 | 6.3% |
| n | 2435 | 6.2% |
| r | 2410 | 6.2% |
| e | 2365 | 6.1% |
| i | 2005 | 5.1% |
| o | 1697 | 4.3% |
| s | 1605 | 4.1% |
| c | 1586 | 4.1% |
| Other values (22) | 12522 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 35482 | |
| Connector Punctuation | 1562 | 4.0% |
| Space Separator | 1251 | 3.2% |
| Decimal Number | 781 | 2.0% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 6444 | |
| t | 3562 | 10.0% |
| m | 2445 | 6.9% |
| n | 2435 | 6.9% |
| r | 2410 | 6.8% |
| e | 2365 | 6.7% |
| i | 2005 | 5.7% |
| o | 1697 | 4.8% |
| s | 1605 | 4.5% |
| c | 1586 | 4.5% |
| Other values (10) | 8928 |
Decimal Number
| Value | Count | Frequency (%) |
| 9 | 95 | |
| 1 | 84 | |
| 0 | 83 | |
| 6 | 77 | |
| 7 | 77 | |
| 8 | 77 | |
| 4 | 75 | |
| 2 | 73 | |
| 5 | 72 | |
| 3 | 68 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 1562 |
Space Separator
| Value | Count | Frequency (%) |
| 1251 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 35482 | |
| Common | 3594 | 9.2% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 6444 | |
| t | 3562 | 10.0% |
| m | 2445 | 6.9% |
| n | 2435 | 6.9% |
| r | 2410 | 6.8% |
| e | 2365 | 6.7% |
| i | 2005 | 5.7% |
| o | 1697 | 4.8% |
| s | 1605 | 4.5% |
| c | 1586 | 4.5% |
| Other values (10) | 8928 |
Common
| Value | Count | Frequency (%) |
| _ | 1562 | |
| 1251 | ||
| 9 | 95 | 2.6% |
| 1 | 84 | 2.3% |
| 0 | 83 | 2.3% |
| 6 | 77 | 2.1% |
| 7 | 77 | 2.1% |
| 8 | 77 | 2.1% |
| 4 | 75 | 2.1% |
| 2 | 73 | 2.0% |
| Other values (2) | 140 | 3.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 39076 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 6444 | |
| t | 3562 | 9.1% |
| m | 2445 | 6.3% |
| n | 2435 | 6.2% |
| r | 2410 | 6.2% |
| e | 2365 | 6.1% |
| i | 2005 | 5.1% |
| o | 1697 | 4.3% |
| s | 1605 | 4.1% |
| c | 1586 | 4.1% |
| Other values (22) | 12522 |
merchant_location
Categorical
| Distinct | 20 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 31.6 KiB |
| Singapore, Singapore | 235 |
|---|---|
| Paris, France | 223 |
| London, UK | 222 |
| Chennai | 219 |
| Dubai, UAE | 219 |
| Other values (15) |
Length
| Max length | 23 |
|---|---|
| Median length | 18 |
| Mean length | 11.530916 |
| Min length | 4 |
Characters and Unicode
| Total characters | 46435 |
|---|---|
| Distinct characters | 42 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Toronto, Canada |
|---|---|
| 2nd row | Cape Town, South Africa |
| 3rd row | Sydney, Australia |
| 4th row | Paris, France |
| 5th row | Kolkata |
Common Values
| Value | Count | Frequency (%) |
| Singapore, Singapore | 235 | 5.8% |
| Paris, France | 223 | 5.5% |
| London, UK | 222 | 5.5% |
| Chennai | 219 | 5.4% |
| Dubai, UAE | 219 | 5.4% |
| Bangalore | 213 | 5.3% |
| Ahmedabad | 207 | 5.1% |
| Tokyo, Japan | 202 | 5.0% |
| Cape Town, South Africa | 202 | 5.0% |
| Hyderabad | 201 | 5.0% |
| Other values (10) | 1884 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| singapore | 470 | 6.5% |
| paris | 223 | 3.1% |
| france | 223 | 3.1% |
| london | 222 | 3.1% |
| uk | 222 | 3.1% |
| chennai | 219 | 3.0% |
| dubai | 219 | 3.0% |
| uae | 219 | 3.0% |
| bangalore | 213 | 2.9% |
| ahmedabad | 207 | 2.9% |
| Other values (25) | 4822 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 5464 | 11.8% |
| o | 3478 | 7.5% |
| n | 3345 | 7.2% |
| 3232 | 7.0% | |
| e | 2854 | 6.1% |
| i | 2800 | 6.0% |
| r | 2670 | 5.7% |
| , | 2066 | 4.4% |
| d | 1601 | 3.4% |
| u | 1358 | 2.9% |
| Other values (32) | 17567 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 32999 | |
| Uppercase Letter | 8138 | 17.5% |
| Space Separator | 3232 | 7.0% |
| Other Punctuation | 2066 | 4.4% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 5464 | |
| o | 3478 | |
| n | 3345 | |
| e | 2854 | 8.6% |
| i | 2800 | 8.5% |
| r | 2670 | 8.1% |
| d | 1601 | 4.9% |
| u | 1358 | 4.1% |
| p | 1068 | 3.2% |
| y | 973 | 2.9% |
| Other values (12) | 7388 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 1057 | |
| A | 1013 | |
| C | 818 | |
| U | 641 | 7.9% |
| T | 601 | 7.4% |
| J | 577 | 7.1% |
| L | 423 | 5.2% |
| P | 415 | 5.1% |
| K | 411 | 5.1% |
| D | 399 | 4.9% |
| Other values (8) | 1783 |
Space Separator
| Value | Count | Frequency (%) |
| 3232 |
Other Punctuation
| Value | Count | Frequency (%) |
| , | 2066 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 41137 | |
| Common | 5298 | 11.4% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 5464 | 13.3% |
| o | 3478 | 8.5% |
| n | 3345 | 8.1% |
| e | 2854 | 6.9% |
| i | 2800 | 6.8% |
| r | 2670 | 6.5% |
| d | 1601 | 3.9% |
| u | 1358 | 3.3% |
| p | 1068 | 2.6% |
| S | 1057 | 2.6% |
| Other values (30) | 15442 |
Common
| Value | Count | Frequency (%) |
| 3232 | ||
| , | 2066 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 46435 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 5464 | 11.8% |
| o | 3478 | 7.5% |
| n | 3345 | 7.2% |
| 3232 | 7.0% | |
| e | 2854 | 6.1% |
| i | 2800 | 6.0% |
| r | 2670 | 5.7% |
| , | 2066 | 4.4% |
| d | 1601 | 3.4% |
| u | 1358 | 2.9% |
| Other values (32) | 17567 |
trans_id
Text
UNIQUE
| Distinct | 4027 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 31.6 KiB |
Length
| Max length | 18 |
|---|---|
| Median length | 18 |
| Mean length | 18 |
| Min length | 18 |
Characters and Unicode
| Total characters | 72486 |
|---|---|
| Distinct characters | 62 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 4027 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | AEBUCBZwjn20SdfGhM |
|---|---|
| 2nd row | JxnOEJ8q7Y61CLUW3m |
| 3rd row | srGxuWPUWLuRlx6ACR |
| 4th row | 5OmAOD8rKVnyn26d5c |
| 5th row | SbZLIak4yqaYK1lbdY |
| Value | Count | Frequency (%) |
| aebucbzwjn20sdfghm | 1 | < 0.1% |
| k7asoi49mzb37ylhne | 1 | < 0.1% |
| unuszi3gg65ju9t1gb | 1 | < 0.1% |
| ylstvtznaeir90pdqu | 1 | < 0.1% |
| srgxuwpuwlurlx6acr | 1 | < 0.1% |
| 5omaod8rkvnyn26d5c | 1 | < 0.1% |
| sbzliak4yqayk1lbdy | 1 | < 0.1% |
| rahmtzc4udfmztrjnn | 1 | < 0.1% |
| f32xiqfpfke6y68dvb | 1 | < 0.1% |
| dpjfgellzxc4rxpg2m | 1 | < 0.1% |
| Other values (4017) | 4017 |
Most occurring characters
| Value | Count | Frequency (%) |
| p | 1253 | 1.7% |
| Q | 1234 | 1.7% |
| C | 1233 | 1.7% |
| Y | 1228 | 1.7% |
| 3 | 1221 | 1.7% |
| 2 | 1220 | 1.7% |
| a | 1214 | 1.7% |
| r | 1212 | 1.7% |
| N | 1209 | 1.7% |
| j | 1204 | 1.7% |
| Other values (52) | 60258 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 30443 | |
| Lowercase Letter | 30323 | |
| Decimal Number | 11720 | 16.2% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| p | 1253 | 4.1% |
| a | 1214 | 4.0% |
| r | 1212 | 4.0% |
| j | 1204 | 4.0% |
| m | 1198 | 4.0% |
| w | 1193 | 3.9% |
| b | 1188 | 3.9% |
| z | 1188 | 3.9% |
| q | 1185 | 3.9% |
| f | 1180 | 3.9% |
| Other values (16) | 18308 |
Uppercase Letter
| Value | Count | Frequency (%) |
| Q | 1234 | 4.1% |
| C | 1233 | 4.1% |
| Y | 1228 | 4.0% |
| N | 1209 | 4.0% |
| J | 1203 | 4.0% |
| D | 1193 | 3.9% |
| F | 1193 | 3.9% |
| P | 1186 | 3.9% |
| S | 1184 | 3.9% |
| H | 1184 | 3.9% |
| Other values (16) | 18396 |
Decimal Number
| Value | Count | Frequency (%) |
| 3 | 1221 | |
| 2 | 1220 | |
| 6 | 1196 | |
| 9 | 1176 | |
| 5 | 1166 | |
| 0 | 1161 | |
| 8 | 1157 | |
| 1 | 1150 | |
| 4 | 1142 | |
| 7 | 1131 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 60766 | |
| Common | 11720 | 16.2% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| p | 1253 | 2.1% |
| Q | 1234 | 2.0% |
| C | 1233 | 2.0% |
| Y | 1228 | 2.0% |
| a | 1214 | 2.0% |
| r | 1212 | 2.0% |
| N | 1209 | 2.0% |
| j | 1204 | 2.0% |
| J | 1203 | 2.0% |
| m | 1198 | 2.0% |
| Other values (42) | 48578 |
Common
| Value | Count | Frequency (%) |
| 3 | 1221 | |
| 2 | 1220 | |
| 6 | 1196 | |
| 9 | 1176 | |
| 5 | 1166 | |
| 0 | 1161 | |
| 8 | 1157 | |
| 1 | 1150 | |
| 4 | 1142 | |
| 7 | 1131 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 72486 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| p | 1253 | 1.7% |
| Q | 1234 | 1.7% |
| C | 1233 | 1.7% |
| Y | 1228 | 1.7% |
| 3 | 1221 | 1.7% |
| 2 | 1220 | 1.7% |
| a | 1214 | 1.7% |
| r | 1212 | 1.7% |
| N | 1209 | 1.7% |
| j | 1204 | 1.7% |
| Other values (52) | 60258 |
UNIQUE
| Distinct | 4027 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 31.6 KiB |
Length
| Max length | 6 |
|---|---|
| Median length | 6 |
| Mean length | 6 |
| Min length | 6 |
Characters and Unicode
| Total characters | 24162 |
|---|---|
| Distinct characters | 36 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 4027 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | 0PQWLM |
|---|---|
| 2nd row | 8BJL8D |
| 3rd row | NK42HM |
| 4th row | JLIPDS |
| 5th row | GPTWZG |
| Value | Count | Frequency (%) |
| 0pqwlm | 1 | < 0.1% |
| w6znh9 | 1 | < 0.1% |
| ap3biu | 1 | < 0.1% |
| 2excuw | 1 | < 0.1% |
| nk42hm | 1 | < 0.1% |
| jlipds | 1 | < 0.1% |
| gptwzg | 1 | < 0.1% |
| ojprhp | 1 | < 0.1% |
| ycxycs | 1 | < 0.1% |
| 3j8b9i | 1 | < 0.1% |
| Other values (4017) | 4017 |
Most occurring characters
| Value | Count | Frequency (%) |
| K | 720 | 3.0% |
| 3 | 717 | 3.0% |
| 7 | 716 | 3.0% |
| B | 708 | 2.9% |
| J | 707 | 2.9% |
| O | 703 | 2.9% |
| G | 698 | 2.9% |
| Z | 693 | 2.9% |
| E | 689 | 2.9% |
| H | 685 | 2.8% |
| Other values (26) | 17126 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 17451 | |
| Decimal Number | 6711 | 27.8% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| K | 720 | 4.1% |
| B | 708 | 4.1% |
| J | 707 | 4.1% |
| O | 703 | 4.0% |
| G | 698 | 4.0% |
| Z | 693 | 4.0% |
| E | 689 | 3.9% |
| H | 685 | 3.9% |
| W | 677 | 3.9% |
| V | 675 | 3.9% |
| Other values (16) | 10496 |
Decimal Number
| Value | Count | Frequency (%) |
| 3 | 717 | |
| 7 | 716 | |
| 9 | 682 | |
| 4 | 679 | |
| 6 | 674 | |
| 1 | 671 | |
| 0 | 671 | |
| 5 | 670 | |
| 2 | 617 | |
| 8 | 614 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 17451 | |
| Common | 6711 | 27.8% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| K | 720 | 4.1% |
| B | 708 | 4.1% |
| J | 707 | 4.1% |
| O | 703 | 4.0% |
| G | 698 | 4.0% |
| Z | 693 | 4.0% |
| E | 689 | 3.9% |
| H | 685 | 3.9% |
| W | 677 | 3.9% |
| V | 675 | 3.9% |
| Other values (16) | 10496 |
Common
| Value | Count | Frequency (%) |
| 3 | 717 | |
| 7 | 716 | |
| 9 | 682 | |
| 4 | 679 | |
| 6 | 674 | |
| 1 | 671 | |
| 0 | 671 | |
| 5 | 670 | |
| 2 | 617 | |
| 8 | 614 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 24162 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| K | 720 | 3.0% |
| 3 | 717 | 3.0% |
| 7 | 716 | 3.0% |
| B | 708 | 2.9% |
| J | 707 | 2.9% |
| O | 703 | 2.9% |
| G | 698 | 2.9% |
| Z | 693 | 2.9% |
| E | 689 | 2.9% |
| H | 685 | 2.8% |
| Other values (26) | 17126 |
trans_loc
Categorical
HIGH CORRELATION
| Distinct | 10 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 31.6 KiB |
| Delhi | |
|---|---|
| Chennai | |
| Pune | |
| Jaipur | |
| Hyderabad | |
| Other values (5) |
Length
| Max length | 9 |
|---|---|
| Median length | 7 |
| Mean length | 6.7698038 |
| Min length | 4 |
Characters and Unicode
| Total characters | 27262 |
|---|---|
| Distinct characters | 29 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Delhi |
|---|---|
| 2nd row | Delhi |
| 3rd row | Jaipur |
| 4th row | Jaipur |
| 5th row | Jaipur |
Common Values
| Value | Count | Frequency (%) |
| Delhi | 507 | |
| Chennai | 472 | |
| Pune | 451 | |
| Jaipur | 419 | |
| Hyderabad | 419 | |
| Kolkata | 406 | |
| Bangalore | 357 | |
| Lucknow | 349 | |
| Mumbai | 329 | |
| Ahmedabad | 318 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| delhi | 507 | |
| chennai | 472 | |
| pune | 451 | |
| jaipur | 419 | |
| hyderabad | 419 | |
| kolkata | 406 | |
| bangalore | 357 | |
| lucknow | 349 | |
| mumbai | 329 | |
| ahmedabad | 318 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 4220 | |
| e | 2524 | 9.3% |
| n | 2101 | 7.7% |
| i | 1727 | 6.3% |
| u | 1548 | 5.7% |
| d | 1474 | 5.4% |
| h | 1297 | 4.8% |
| l | 1270 | 4.7% |
| r | 1195 | 4.4% |
| o | 1112 | 4.1% |
| Other values (19) | 8794 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 23235 | |
| Uppercase Letter | 4027 | 14.8% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 4220 | |
| e | 2524 | |
| n | 2101 | |
| i | 1727 | 7.4% |
| u | 1548 | 6.7% |
| d | 1474 | 6.3% |
| h | 1297 | 5.6% |
| l | 1270 | 5.5% |
| r | 1195 | 5.1% |
| o | 1112 | 4.8% |
| Other values (9) | 4767 |
Uppercase Letter
| Value | Count | Frequency (%) |
| D | 507 | |
| C | 472 | |
| P | 451 | |
| H | 419 | |
| J | 419 | |
| K | 406 | |
| B | 357 | |
| L | 349 | |
| M | 329 | |
| A | 318 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 27262 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 4220 | |
| e | 2524 | 9.3% |
| n | 2101 | 7.7% |
| i | 1727 | 6.3% |
| u | 1548 | 5.7% |
| d | 1474 | 5.4% |
| h | 1297 | 4.8% |
| l | 1270 | 4.7% |
| r | 1195 | 4.4% |
| o | 1112 | 4.1% |
| Other values (19) | 8794 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 27262 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 4220 | |
| e | 2524 | 9.3% |
| n | 2101 | 7.7% |
| i | 1727 | 6.3% |
| u | 1548 | 5.7% |
| d | 1474 | 5.4% |
| h | 1297 | 4.8% |
| l | 1270 | 4.7% |
| r | 1195 | 4.4% |
| o | 1112 | 4.1% |
| Other values (19) | 8794 |
trans_cat
Categorical
| Distinct | 7 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 31.6 KiB |
| Travel | |
|---|---|
| Grocery | |
| Dining | |
| Retail | |
| Other | |
| Other values (2) |
Length
| Max length | 13 |
|---|---|
| Median length | 9 |
| Mean length | 7.4012913 |
| Min length | 5 |
Characters and Unicode
| Total characters | 29805 |
|---|---|
| Distinct characters | 22 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Entertainment |
|---|---|
| 2nd row | Grocery |
| 3rd row | Utilities |
| 4th row | Grocery |
| 5th row | Dining |
Common Values
| Value | Count | Frequency (%) |
| Travel | 594 | |
| Grocery | 587 | |
| Dining | 586 | |
| Retail | 572 | |
| Other | 571 | |
| Entertainment | 569 | |
| Utilities | 548 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| travel | 594 | |
| grocery | 587 | |
| dining | 586 | |
| retail | 572 | |
| other | 571 | |
| entertainment | 569 | |
| utilities | 548 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 4010 | |
| i | 3957 | |
| t | 3946 | |
| r | 2908 | |
| n | 2879 | |
| a | 1735 | 5.8% |
| l | 1714 | 5.8% |
| T | 594 | 2.0% |
| v | 594 | 2.0% |
| c | 587 | 2.0% |
| Other values (12) | 6881 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 25778 | |
| Uppercase Letter | 4027 | 13.5% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 4010 | |
| i | 3957 | |
| t | 3946 | |
| r | 2908 | |
| n | 2879 | |
| a | 1735 | |
| l | 1714 | |
| v | 594 | 2.3% |
| c | 587 | 2.3% |
| y | 587 | 2.3% |
| Other values (5) | 2861 |
Uppercase Letter
| Value | Count | Frequency (%) |
| T | 594 | |
| G | 587 | |
| D | 586 | |
| R | 572 | |
| O | 571 | |
| E | 569 | |
| U | 548 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 29805 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 4010 | |
| i | 3957 | |
| t | 3946 | |
| r | 2908 | |
| n | 2879 | |
| a | 1735 | 5.8% |
| l | 1714 | 5.8% |
| T | 594 | 2.0% |
| v | 594 | 2.0% |
| c | 587 | 2.0% |
| Other values (12) | 6881 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 29805 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 4010 | |
| i | 3957 | |
| t | 3946 | |
| r | 2908 | |
| n | 2879 | |
| a | 1735 | 5.8% |
| l | 1714 | 5.8% |
| T | 594 | 2.0% |
| v | 594 | 2.0% |
| c | 587 | 2.0% |
| Other values (12) | 6881 |
trans_currency
Categorical
HIGH CORRELATION IMBALANCE
| Distinct | 7 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 31.6 KiB |
| INR | |
|---|---|
| CAD | 136 |
| EUR | 135 |
| AUD | 124 |
| Other | 114 |
| Other values (2) | 222 |
Length
| Max length | 5 |
|---|---|
| Median length | 3 |
| Mean length | 3.0566178 |
| Min length | 3 |
Characters and Unicode
| Total characters | 12309 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | INR |
|---|---|
| 2nd row | EUR |
| 3rd row | INR |
| 4th row | INR |
| 5th row | EUR |
Common Values
| Value | Count | Frequency (%) |
| INR | 3296 | |
| CAD | 136 | 3.4% |
| EUR | 135 | 3.4% |
| AUD | 124 | 3.1% |
| Other | 114 | 2.8% |
| JPY | 113 | 2.8% |
| USD | 109 | 2.7% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| inr | 3296 | |
| cad | 136 | 3.4% |
| eur | 135 | 3.4% |
| aud | 124 | 3.1% |
| other | 114 | 2.8% |
| jpy | 113 | 2.8% |
| usd | 109 | 2.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| R | 3431 | |
| I | 3296 | |
| N | 3296 | |
| D | 369 | 3.0% |
| U | 368 | 3.0% |
| A | 260 | 2.1% |
| C | 136 | 1.1% |
| E | 135 | 1.1% |
| e | 114 | 0.9% |
| r | 114 | 0.9% |
| Other values (7) | 790 | 6.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 11853 | |
| Lowercase Letter | 456 | 3.7% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| R | 3431 | |
| I | 3296 | |
| N | 3296 | |
| D | 369 | 3.1% |
| U | 368 | 3.1% |
| A | 260 | 2.2% |
| C | 136 | 1.1% |
| E | 135 | 1.1% |
| O | 114 | 1.0% |
| J | 113 | 1.0% |
| Other values (3) | 335 | 2.8% |
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 114 | |
| r | 114 | |
| h | 114 | |
| t | 114 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 12309 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| R | 3431 | |
| I | 3296 | |
| N | 3296 | |
| D | 369 | 3.0% |
| U | 368 | 3.0% |
| A | 260 | 2.1% |
| C | 136 | 1.1% |
| E | 135 | 1.1% |
| e | 114 | 0.9% |
| r | 114 | 0.9% |
| Other values (7) | 790 | 6.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 12309 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| R | 3431 | |
| I | 3296 | |
| N | 3296 | |
| D | 369 | 3.0% |
| U | 368 | 3.0% |
| A | 260 | 2.1% |
| C | 136 | 1.1% |
| E | 135 | 1.1% |
| e | 114 | 0.9% |
| r | 114 | 0.9% |
| Other values (7) | 790 | 6.4% |
mcc
Real number (ℝ)
| Distinct | 20 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4008.2754 |
| Minimum | 4000 |
|---|---|
| Maximum | 4019 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 31.6 KiB |
Quantile statistics
| Minimum | 4000 |
|---|---|
| 5-th percentile | 4001 |
| Q1 | 4003 |
| median | 4008 |
| Q3 | 4013 |
| 95-th percentile | 4017 |
| Maximum | 4019 |
| Range | 19 |
| Interquartile range (IQR) | 10 |
Descriptive statistics
| Standard deviation | 5.3969963 |
|---|---|
| Coefficient of variation (CV) | 0.0013464634 |
| Kurtosis | -1.1717825 |
| Mean | 4008.2754 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | 0.2417021 |
| Sum | 16141325 |
| Variance | 29.127569 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=20)
| Value | Count | Frequency (%) |
| 4005 | 415 | 10.3% |
| 4003 | 361 | 9.0% |
| 4001 | 343 | 8.5% |
| 4014 | 305 | 7.6% |
| 4006 | 304 | 7.5% |
| 4016 | 301 | 7.5% |
| 4009 | 266 | 6.6% |
| 4010 | 242 | 6.0% |
| 4002 | 237 | 5.9% |
| 4012 | 185 | 4.6% |
| Other values (10) | 1068 |
| Value | Count | Frequency (%) |
| 4000 | 114 | 2.8% |
| 4001 | 343 | |
| 4002 | 237 | |
| 4003 | 361 | |
| 4004 | 108 | 2.7% |
| 4005 | 415 | |
| 4006 | 304 | |
| 4007 | 61 | 1.5% |
| 4008 | 183 | |
| 4009 | 266 |
| Value | Count | Frequency (%) |
| 4019 | 69 | 1.7% |
| 4018 | 79 | 2.0% |
| 4017 | 124 | |
| 4016 | 301 | |
| 4015 | 72 | 1.8% |
| 4014 | 305 | |
| 4013 | 162 | |
| 4012 | 185 | |
| 4011 | 96 | 2.4% |
| 4010 | 242 |
trans_amount
Real number (ℝ)
HIGH CORRELATION
| Distinct | 3348 |
|---|---|
| Distinct (%) | 83.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10876.342 |
| Minimum | 1.08 |
|---|---|
| Maximum | 49924.762 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 31.6 KiB |
Quantile statistics
| Minimum | 1.08 |
|---|---|
| 5-th percentile | 9.6650001 |
| Q1 | 41 |
| median | 2390.76 |
| Q3 | 19626.96 |
| 95-th percentile | 43557.77 |
| Maximum | 49924.762 |
| Range | 49923.682 |
| Interquartile range (IQR) | 19585.96 |
Descriptive statistics
| Standard deviation | 15069.316 |
|---|---|
| Coefficient of variation (CV) | 1.3855132 |
| Kurtosis | 0.058913674 |
| Mean | 10876.342 |
| Median Absolute Deviation (MAD) | 2368.76 |
| Skewness | 1.2287814 |
| Sum | 43799031 |
| Variance | 2.2708429 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 17 | 21 | 0.5% |
| 41 | 20 | 0.5% |
| 7 | 20 | 0.5% |
| 30 | 19 | 0.5% |
| 3 | 19 | 0.5% |
| 42 | 18 | 0.4% |
| 45 | 17 | 0.4% |
| 46 | 17 | 0.4% |
| 28 | 17 | 0.4% |
| 23 | 17 | 0.4% |
| Other values (3338) | 3842 |
| Value | Count | Frequency (%) |
| 1.080000043 | 1 | |
| 1.129999995 | 1 | |
| 1.200000048 | 1 | |
| 1.389999986 | 1 | |
| 1.419999957 | 1 | |
| 1.470000029 | 1 | |
| 1.629999995 | 1 | |
| 1.659999967 | 1 | |
| 1.679999948 | 1 | |
| 1.870000005 | 1 |
| Value | Count | Frequency (%) |
| 49924.76172 | 1 | |
| 49918 | 1 | |
| 49909 | 1 | |
| 49881 | 1 | |
| 49821 | 1 | |
| 49780 | 1 | |
| 49753.12109 | 1 | |
| 49751 | 1 | |
| 49748 | 1 | |
| 49744.96875 | 1 |
trans_date
Date
| Distinct | 4022 |
|---|---|
| Distinct (%) | 99.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 31.6 KiB |
| Minimum | 2023-08-10 06:20:36 |
|---|---|
| Maximum | 2023-09-09 06:11:57 |
Histogram with fixed size bins (bins=50)
trans_payment_method
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 31.6 KiB |
| Credit Card | |
|---|---|
| Debit Card |
Length
| Max length | 11 |
|---|---|
| Median length | 11 |
| Mean length | 10.505587 |
| Min length | 10 |
Characters and Unicode
| Total characters | 42306 |
|---|---|
| Distinct characters | 10 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Credit Card |
|---|---|
| 2nd row | Credit Card |
| 3rd row | Debit Card |
| 4th row | Credit Card |
| 5th row | Credit Card |
Common Values
| Value | Count | Frequency (%) |
| Credit Card | 2036 | |
| Debit Card | 1991 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| card | 4027 | |
| credit | 2036 | |
| debit | 1991 |
Most occurring characters
| Value | Count | Frequency (%) |
| C | 6063 | |
| r | 6063 | |
| d | 6063 | |
| e | 4027 | |
| i | 4027 | |
| t | 4027 | |
| 4027 | ||
| a | 4027 | |
| D | 1991 | 4.7% |
| b | 1991 | 4.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 30225 | |
| Uppercase Letter | 8054 | 19.0% |
| Space Separator | 4027 | 9.5% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| r | 6063 | |
| d | 6063 | |
| e | 4027 | |
| i | 4027 | |
| t | 4027 | |
| a | 4027 | |
| b | 1991 | 6.6% |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 6063 | |
| D | 1991 | 24.7% |
Space Separator
| Value | Count | Frequency (%) |
| 4027 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 38279 | |
| Common | 4027 | 9.5% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| C | 6063 | |
| r | 6063 | |
| d | 6063 | |
| e | 4027 | |
| i | 4027 | |
| t | 4027 | |
| a | 4027 | |
| D | 1991 | 5.2% |
| b | 1991 | 5.2% |
Common
| Value | Count | Frequency (%) |
| 4027 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 42306 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| C | 6063 | |
| r | 6063 | |
| d | 6063 | |
| e | 4027 | |
| i | 4027 | |
| t | 4027 | |
| 4027 | ||
| a | 4027 | |
| D | 1991 | 4.7% |
| b | 1991 | 4.7% |
trans_verify_method
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 31.6 KiB |
| PIN | |
|---|---|
| Biometric |
Length
| Max length | 9 |
|---|---|
| Median length | 3 |
| Mean length | 5.9813757 |
| Min length | 3 |
Characters and Unicode
| Total characters | 24087 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Biometric |
|---|---|
| 2nd row | PIN |
| 3rd row | PIN |
| 4th row | PIN |
| 5th row | PIN |
Common Values
| Value | Count | Frequency (%) |
| PIN | 2026 | |
| Biometric | 2001 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| pin | 2026 | |
| biometric | 2001 |
Most occurring characters
| Value | Count | Frequency (%) |
| i | 4002 | |
| P | 2026 | |
| I | 2026 | |
| N | 2026 | |
| B | 2001 | |
| o | 2001 | |
| m | 2001 | |
| e | 2001 | |
| t | 2001 | |
| r | 2001 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 16008 | |
| Uppercase Letter | 8079 |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| i | 4002 | |
| o | 2001 | |
| m | 2001 | |
| e | 2001 | |
| t | 2001 | |
| r | 2001 | |
| c | 2001 |
Uppercase Letter
| Value | Count | Frequency (%) |
| P | 2026 | |
| I | 2026 | |
| N | 2026 | |
| B | 2001 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 24087 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| i | 4002 | |
| P | 2026 | |
| I | 2026 | |
| N | 2026 | |
| B | 2001 | |
| o | 2001 | |
| m | 2001 | |
| e | 2001 | |
| t | 2001 | |
| r | 2001 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 24087 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| i | 4002 | |
| P | 2026 | |
| I | 2026 | |
| N | 2026 | |
| B | 2001 | |
| o | 2001 | |
| m | 2001 | |
| e | 2001 | |
| t | 2001 | |
| r | 2001 |
trans_status
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 31.6 KiB |
| Transfer | |
|---|---|
| Payment | |
| Purchase |
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 7.6637696 |
| Min length | 7 |
Characters and Unicode
| Total characters | 30862 |
|---|---|
| Distinct characters | 14 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Transfer |
|---|---|
| 2nd row | Transfer |
| 3rd row | Transfer |
| 4th row | Purchase |
| 5th row | Transfer |
Common Values
| Value | Count | Frequency (%) |
| Transfer | 1360 | |
| Payment | 1354 | |
| Purchase | 1313 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| transfer | 1360 | |
| payment | 1354 | |
| purchase | 1313 |
Most occurring characters
| Value | Count | Frequency (%) |
| r | 4033 | |
| a | 4027 | |
| e | 4027 | |
| n | 2714 | |
| s | 2673 | |
| P | 2667 | |
| T | 1360 | 4.4% |
| f | 1360 | 4.4% |
| y | 1354 | 4.4% |
| m | 1354 | 4.4% |
| Other values (4) | 5293 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 26835 | |
| Uppercase Letter | 4027 | 13.0% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| r | 4033 | |
| a | 4027 | |
| e | 4027 | |
| n | 2714 | |
| s | 2673 | |
| f | 1360 | 5.1% |
| y | 1354 | 5.0% |
| m | 1354 | 5.0% |
| t | 1354 | 5.0% |
| u | 1313 | 4.9% |
| Other values (2) | 2626 |
Uppercase Letter
| Value | Count | Frequency (%) |
| P | 2667 | |
| T | 1360 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 30862 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| r | 4033 | |
| a | 4027 | |
| e | 4027 | |
| n | 2714 | |
| s | 2673 | |
| P | 2667 | |
| T | 1360 | 4.4% |
| f | 1360 | 4.4% |
| y | 1354 | 4.4% |
| m | 1354 | 4.4% |
| Other values (4) | 5293 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 30862 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| r | 4033 | |
| a | 4027 | |
| e | 4027 | |
| n | 2714 | |
| s | 2673 | |
| P | 2667 | |
| T | 1360 | 4.4% |
| f | 1360 | 4.4% |
| y | 1354 | 4.4% |
| m | 1354 | 4.4% |
| Other values (4) | 5293 |
fake
Boolean
HIGH CORRELATION
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.1 KiB |
| False | |
|---|---|
| True |
| Value | Count | Frequency (%) |
| False | 2522 | |
| True | 1505 |
| card_number | customer_age | mcc | trans_amount | customer_segment | card_type | customer_location | merchant_name | merchant_location | trans_loc | trans_cat | trans_currency | trans_payment_method | trans_verify_method | trans_status | fake | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| card_number | 1.000 | 0.017 | 0.041 | -0.007 | 0.868 | 0.868 | 0.868 | 0.000 | 0.000 | 0.868 | 0.000 | 0.058 | 0.078 | 0.111 | 0.086 | 0.000 |
| customer_age | 0.017 | 1.000 | -0.018 | -0.010 | 0.072 | 0.069 | 0.076 | 0.000 | 0.000 | 0.076 | 0.023 | 0.011 | 0.014 | 0.000 | 0.007 | 0.000 |
| mcc | 0.041 | -0.018 | 1.000 | -0.021 | 0.019 | 0.013 | 0.000 | 0.000 | 0.012 | 0.000 | 0.025 | 0.011 | 0.037 | 0.022 | 0.009 | 0.037 |
| trans_amount | -0.007 | -0.010 | -0.021 | 1.000 | 0.000 | 0.022 | 0.000 | 0.221 | 0.030 | 0.000 | 0.034 | 0.257 | 0.000 | 0.007 | 0.018 | 0.999 |
| customer_segment | 0.868 | 0.072 | 0.019 | 0.000 | 1.000 | 0.042 | 0.091 | 0.000 | 0.014 | 0.091 | 0.011 | 0.000 | 0.014 | 0.040 | 0.000 | 0.000 |
| card_type | 0.868 | 0.069 | 0.013 | 0.022 | 0.042 | 1.000 | 0.092 | 0.000 | 0.032 | 0.092 | 0.013 | 0.000 | 0.000 | 0.000 | 0.011 | 0.000 |
| customer_location | 0.868 | 0.076 | 0.000 | 0.000 | 0.091 | 0.092 | 1.000 | 0.000 | 0.000 | 1.000 | 0.000 | 0.027 | 0.000 | 0.035 | 0.020 | 0.000 |
| merchant_name | 0.000 | 0.000 | 0.000 | 0.221 | 0.000 | 0.000 | 0.000 | 1.000 | 0.019 | 0.000 | 0.020 | 0.163 | 0.000 | 0.000 | 0.000 | 0.633 |
| merchant_location | 0.000 | 0.000 | 0.012 | 0.030 | 0.014 | 0.032 | 0.000 | 0.019 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.012 | 0.041 | 0.021 |
| trans_loc | 0.868 | 0.076 | 0.000 | 0.000 | 0.091 | 0.092 | 1.000 | 0.000 | 0.000 | 1.000 | 0.000 | 0.027 | 0.000 | 0.035 | 0.020 | 0.000 |
| trans_cat | 0.000 | 0.023 | 0.025 | 0.034 | 0.011 | 0.013 | 0.000 | 0.020 | 0.000 | 0.000 | 1.000 | 0.015 | 0.000 | 0.012 | 0.021 | 0.061 |
| trans_currency | 0.058 | 0.011 | 0.011 | 0.257 | 0.000 | 0.000 | 0.027 | 0.163 | 0.000 | 0.027 | 0.015 | 1.000 | 0.000 | 0.000 | 0.000 | 0.608 |
| trans_payment_method | 0.078 | 0.014 | 0.037 | 0.000 | 0.014 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 0.000 | 0.000 | 0.000 |
| trans_verify_method | 0.111 | 0.000 | 0.022 | 0.007 | 0.040 | 0.000 | 0.035 | 0.000 | 0.012 | 0.035 | 0.012 | 0.000 | 0.000 | 1.000 | 0.024 | 0.021 |
| trans_status | 0.086 | 0.007 | 0.009 | 0.018 | 0.000 | 0.011 | 0.020 | 0.000 | 0.041 | 0.020 | 0.021 | 0.000 | 0.000 | 0.024 | 1.000 | 0.000 |
| fake | 0.000 | 0.000 | 0.037 | 0.999 | 0.000 | 0.000 | 0.000 | 0.633 | 0.021 | 0.000 | 0.061 | 0.608 | 0.000 | 0.021 | 0.000 | 1.000 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
| cardholder_name | card_number | customer_age | customer_segment | card_type | customer_location | merchant_name | merchant_location | trans_id | trans_approval_code | trans_loc | trans_cat | trans_currency | mcc | trans_amount | trans_date | trans_payment_method | trans_verify_method | trans_status | fake | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | Kaitlin Edwards | 103313584129 | 18 | Business | MasterCard | Delhi | airtel | Toronto, Canada | AEBUCBZwjn20SdfGhM | 0PQWLM | Delhi | Entertainment | INR | 4011 | 2237.000000 | 2023-08-24 20:00:22 | Credit Card | Biometric | Transfer | False |
| 1 | Kaitlin Edwards | 103313584129 | 18 | Business | MasterCard | Delhi | amazon | Cape Town, South Africa | JxnOEJ8q7Y61CLUW3m | 8BJL8D | Delhi | Grocery | EUR | 4007 | 13546.000000 | 2023-08-24 20:00:47 | Credit Card | PIN | Transfer | True |
| 2 | Kyle Armstrong | 791300507301 | 64 | Retail | American Express | Jaipur | chai talks | Sydney, Australia | srGxuWPUWLuRlx6ACR | NK42HM | Jaipur | Utilities | INR | 4001 | 36.419998 | 2023-08-25 09:09:36 | Debit Card | PIN | Transfer | False |
| 3 | Kyle Armstrong | 791300507301 | 64 | Retail | American Express | Jaipur | fake_merchant_6 | Paris, France | 5OmAOD8rKVnyn26d5c | JLIPDS | Jaipur | Grocery | INR | 4017 | 13674.389648 | 2023-08-25 22:01:21 | Credit Card | PIN | Purchase | True |
| 4 | Kyle Armstrong | 791300507301 | 64 | Retail | American Express | Jaipur | instamart | Kolkata | SbZLIak4yqaYK1lbdY | GPTWZG | Jaipur | Dining | EUR | 4009 | 47821.578125 | 2023-08-29 14:54:21 | Credit Card | PIN | Transfer | True |
| 5 | Stephanie Washington | 973891787445 | 42 | Student | Rupay | Mumbai | amazon gift cards | New York City, USA | rAHmTzC4udFmzTRJNN | OJPRHP | Mumbai | Retail | INR | 4012 | 705.000000 | 2023-08-13 09:31:36 | Debit Card | Biometric | Transfer | False |
| 6 | Stephanie Washington | 973891787445 | 42 | Student | Rupay | Mumbai | chai talks | Paris, France | f32xiqFPFkE6y68dvB | YCXYCS | Mumbai | Travel | Other | 4001 | 8145.000000 | 2023-08-19 22:34:05 | Debit Card | Biometric | Purchase | True |
| 7 | Jennifer Russell DVM | 125611765277 | 29 | Retail | American Express | Hyderabad | amazon | London, UK | dpJFgELLzXC4rxpg2m | 3J8B9I | Hyderabad | Retail | INR | 4006 | 24.370001 | 2023-08-16 13:17:11 | Credit Card | Biometric | Purchase | False |
| 8 | Jennifer Russell DVM | 125611765277 | 29 | Retail | American Express | Hyderabad | fake_merchant_4 | Dubai, UAE | Xsccxz3k7php9ByBkN | 79WPCU | Hyderabad | Travel | AUD | 4005 | 19232.589844 | 2023-09-02 03:07:06 | Credit Card | PIN | Purchase | True |
| 9 | Jennifer Russell DVM | 125611765277 | 29 | Retail | American Express | Hyderabad | zomato | Hyderabad | uylbQmwaIFCYmqObvI | LDC09W | Hyderabad | Other | INR | 4000 | 21779.000000 | 2023-09-04 23:38:51 | Debit Card | PIN | Payment | True |
| cardholder_name | card_number | customer_age | customer_segment | card_type | customer_location | merchant_name | merchant_location | trans_id | trans_approval_code | trans_loc | trans_cat | trans_currency | mcc | trans_amount | trans_date | trans_payment_method | trans_verify_method | trans_status | fake | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4017 | Angela Beltran | 281455872457 | 39 | Other | Other | Lucknow | airtel | Delhi | aQJGKbGoZ0yKJzAr76 | 3BAFQU | Lucknow | Travel | INR | 4002 | 2803.000000 | 2023-09-07 00:35:10 | Debit Card | PIN | Purchase | False |
| 4018 | Angela Beltran | 281455872457 | 39 | Other | Other | Lucknow | rakuten | London, UK | pfLm74WaQYgxALbQZ3 | 643BCA | Lucknow | Entertainment | INR | 4005 | 3414.000000 | 2023-09-08 18:48:04 | Debit Card | PIN | Transfer | False |
| 4019 | Angela Beltran | 281455872457 | 39 | Other | Other | Lucknow | zomato | Chennai | agljIfFQunE4tyLEfP | IJ0TWX | Lucknow | Grocery | CAD | 4016 | 42420.000000 | 2023-09-08 20:25:43 | Credit Card | Biometric | Purchase | True |
| 4020 | Angela Beltran | 281455872457 | 39 | Other | Other | Lucknow | rakuten | London, UK | OSuNrJPA1NEO3gLkKZ | CN7W7R | Lucknow | Dining | INR | 4005 | 42573.378906 | 2023-09-08 21:51:53 | Credit Card | PIN | Payment | True |
| 4021 | Ashley Garrett | 794550778485 | 29 | Other | Visa | Bangalore | swiggy | New York City, USA | C01WEuQem3LaesQpFi | IWNQOC | Bangalore | Retail | INR | 4007 | 39.000000 | 2023-08-17 23:03:37 | Credit Card | PIN | Transfer | False |
| 4022 | Ashley Garrett | 794550778485 | 29 | Other | Visa | Bangalore | chai talks | Dubai, UAE | VFHZYPdizRqt4RGlyJ | 0751NG | Bangalore | Utilities | INR | 4010 | 19.000000 | 2023-08-22 13:42:45 | Debit Card | Biometric | Payment | False |
| 4023 | Ashley Garrett | 794550778485 | 29 | Other | Visa | Bangalore | zomato | Rio de Janeiro, Brazil | Nhl1drXCajpf56Yrtd | CFNWYV | Bangalore | Other | INR | 4015 | 35.730000 | 2023-09-05 00:14:46 | Credit Card | Biometric | Payment | False |
| 4024 | Ashley Garrett | 794550778485 | 29 | Other | Visa | Bangalore | instamart | Jaipur | KXmMkpFK0bkHgDIL6C | E14GSP | Bangalore | Retail | INR | 4016 | 48.000000 | 2023-09-06 16:57:46 | Credit Card | PIN | Payment | False |
| 4025 | Ashley Garrett | 794550778485 | 29 | Other | Visa | Bangalore | airtel | Bangalore | QdFkY0E8J0pW6GzhmM | ZWAD4S | Bangalore | Entertainment | INR | 4009 | 24696.000000 | 2023-09-08 15:35:16 | Debit Card | Biometric | Transfer | True |
| 4026 | Ashley Garrett | 794550778485 | 29 | Other | Visa | Bangalore | rakuten | Bangalore | tXilEM5m3NxI6WYIq1 | JS6JHI | Bangalore | Utilities | USD | 4006 | 9280.509766 | 2023-09-08 21:10:55 | Credit Card | Biometric | Purchase | True |